Detailed Business Process Model Description : GL Integration Configuration : Oracle Utilities Customer Care and Billing Configuration

Oracle Utilities Customer Care and Billing Configuration
GL Integration Point
To enable this integration point you must configure the following information in Oracle Utilities Customer Care and Billing.
Configure GL Division
If you decide to integrate the financial transactions for a specific GL Division in Oracle Utilities Customer Care and Billing to E-Business Suite, identify the GL Division.
Configure Distribution Codes
You must map your distribution codes in Oracle Utilities Customer Care and Billing with the appropriate GL Accounts in the Oracle E-Business Suite Revenue Accounting GL. First configure the distribution codes and then assign them to various entities within the Oracle Utilities Customer Care and Billing applications.
Oracle Applications GL accounts are structured using account segments. These are set up in your existing Oracle E-Business Suite Revenue Accounting system according to your business practices. Oracle Utilities Customer Care and Billing distribution codes must be configured to mirror the segments & Values in Oracle E-Business Suite Revenue Accounting. The segment positions are fixed in Customer Care and Billing so that the first segment is Account, the second segment is Department ID, and so on, as shown in the following table.
 
Oracle E-Business Suite Revenue Accounting Account Column name
Oracle Utilities Customer Care and Billing Distribution (GL_ACCT) segment position
A sample GL Account string is 01-520-5250-0000-000
When interpreted by the standard mapping in the product this GL Account String in the sub ledger equates to the following in the Oracle Applications GL:
When interpreted by the standard mapping in the product this GL Account String in the sub ledger equates to the following in the Oracle JD Edwards EnterpriseOne Financial Management GL:
Note: Only fields relevant to the integration are included in this table.
 
The distribution code to be used for financial transactions of a certain type.
Example: Electric residential revenue
A description of how the distribution code is used.
The standard product, or customer modified, algorithm you use for determining the GL Account String from the distribution code.
Create at least one set of account details as needed by your chosen algorithm above. Only one will be used based on status and effective date.
The date you wish the following GL Account string to become active and used by the system, and therefore, the integration software.
Only active status accounts will be used by product and therefore, the integration.
Input the GL Account String as explained above.
Note: Only fields relevant to the integration are included in this table.
Configure GLASSIGN, and GLS for Oracle Utilities Customer Care and Billing Extract
To successfully execute extracts from Oracle Utilities Customer Care and Billing, two processes must be configured with the appropriate batch parameters and set to run on a scheduled basis. These processes can be scheduled using the Oracle Utilities Customer Care and Billing scheduling tool or an enterprise scheduler that meets the open architecture standards used by Oracle Utilities Customer Care and Billing.

© 2011 Oracle and/or its affiliates. All Rights Reserved